package com.carleasoft.mps.cms.business.user.dao;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.carleasoft.mps.cms.business.user.bean.UserSkill;
import com.carleasoft.mps.cms.business.user.bean.UserSkillType;
import com.carleasoft.mps.cms.business.user.bean.po.UserSkillPo;
import com.carleasoft.mps.cms.business.user.bean.vo.DeptCountVo;
import com.carleasoft.mps.cms.business.user.bean.vo.SkillInfo;
import com.carleasoft.mps.cms.business.user.bean.vo.UserInfoVo;
import com.carleasoft.mps.cms.business.write.bean.vo.UserListVos;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author zang
 * @since 2023-05-25
 */
@Mapper
public interface UserSkillMapper extends BaseMapper<UserSkill> {

    Page<UserSkill> pageUserSkill(Page page, @Param("po") UserSkillPo userSkillPo);

    List<UserSkillType> userInfo(@Param("po") UserSkillPo userSkillPo);

    Integer technology(@Param("po") UserSkillPo userSkillPo);

    List<UserInfoVo> heightAndWeight(@Param("po") UserSkillPo userSkillPo);

    List<SkillInfo> SkillInfo();

    List<String> skillCount(@Param("po") UserSkillPo userSkillPo);

    Integer ageCount(@Param("po") UserSkillPo userSkillPo);

    Integer marriage(@Param("po") UserSkillPo userSkillPo);

    List<SkillInfo> educationCount(@Param("po") UserSkillPo userSkillPo);

    List<SkillInfo> commandCount();

    List<String> list(@Param("po") UserSkillPo userSkillPo);

    Integer UserCountVo();

    List<UserListVos> deptCodeByUserList(@Param("po") UserSkill userSkill);

    List<DeptCountVo> deptList(@Param("po") UserSkillPo userSkillPo);

    Integer deptCount(@Param("deptCode") String deptCode);

    List<UserSkill> getUserSkillTypeList(@Param("po") UserSkill userSkill);
}
